/*
 * Powered By free
 * Web Site: 
 * Since 2018 - 2021
 */
package com.menhai.personmanagement.mapper;

import java.util.List;
import java.util.Map;

import com.menhai.personmanagement.entity.co.TjSkCo;
import com.menhai.personmanagement.entity.vo.TjInspectphysicalVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.menhai.personmanagement.entity.co.TjInspectphysicalCo;

@Mapper
public interface TjQueryMapper{
	
	

	IPage<List<Map<String,Object>>> getTjRecordListByConditionByPage(@Param("page")Page<TjInspectphysicalCo> page,@Param("tjInspectphysical")TjInspectphysicalCo tjInspectphysical);

	List<Map<String,Object>> getTjRecordListByCondition(@Param("tjInspectphysical")TjInspectphysicalCo tjInspectphysical);

	
	public List<Map<String,Object>> getTjRecordOneById(TjInspectphysicalCo tjInspectphysical);

	IPage<List<Map<String,Object>>> getTjrcListByConditionByPage(@Param("page")Page<TjInspectphysicalCo> page,@Param("tjInspectphysical")TjInspectphysicalCo tjInspectphysical);

	@Select("select l.codeValue hosnum,l.codeName hosname from codelist l where l.kindcode='YYMC' and length(l.codeValue)=8 and l.codeValue like '${hosnum}%' ORDER BY l.codeValue asc")
	public List<Map<String,Object>> getCun(@Param("hosnum")String hosnum);

	IPage<List<Map<String,Object>>> finishbodycheckup(@Param("page") Page<TjInspectphysicalCo> page,@Param("tjInspectphysical")TjInspectphysicalCo tjInspectphysical);

	public List tjjlgecunrenshu();
}
